﻿/*CREATE TRIGGER [dbo].[CultivosClasificaciones_DeletionTrigger] 
    ON [CultivosClasificaciones] 
    AFTER DELETE 
AS 
SET NOCOUNT ON 
UPDATE [dbo].[CultivosClasificaciones_Tombstone] 
    SET [DeletionDate] = GETUTCDATE() 
    FROM deleted 
    WHERE deleted.[ClasificacionGuid] = [CultivosClasificaciones_Tombstone].[ClasificacionGuid] 
IF @@ROWCOUNT = 0 
BEGIN 
    INSERT INTO [dbo].[CultivosClasificaciones_Tombstone] 
    ([ClasificacionGuid], DeletionDate)
    SELECT [ClasificacionGuid], GETUTCDATE()
    FROM deleted 
END*/